On the occasion of the 2024 UN World Data Forum, we will here examine a data frame (source) containing information about the number, nationality and gender of people entering Colombia between 2012 and 2022.

Total Number of Entries

Different Nationalities

Number of Entries per Year by Gender

We see here a steady increase until the COVID years, with 2022 that reattained pre-2018 levels. We have a slight prevalence of male entries, with yearly percentages that range from 55% to 63%.

Over the 11 years, 16,420,124 males (58%) and 11,766,217 females (42%) have entered (to note, there is an inconsistency -of 1,227- between the gender values and the Total column values, while the “Indefinido” gender column is empty all along the 11 years).

For context, Colombia had a population of 45,308,899 in 2011 and of 51,737,944 in 2022.

The chart is interactive.

Number of Entries per Month, differentiating by Year

About the months of entry, we can generally see July, August and December as the major ones.

The difference, along the year, between the month with the fewest entries and the one with the most incremented from 41,993 in 2012 to 101,857 in 2019.

Hovering over a line, by the x axis grid lines, will highlight it, showing the monthly value as well. A double-click will undo the selection.

World Map of Entries

Among the 239 different nationalities, the majority of entries stem from Venezuela (20.11% over the total) and US (19.65%), followed by other American and European Countries, with percentages starting from 5.52% for Mexico and 4.22% for Spain.

We also have 20747 entries with a 99999 iso3166 code, for values like Refugee, Palestine, Tibet, Yugoslavia and Unknown.

Is it possible to hover over the countries to visualize the total amount of entries over the 11 years. More entries per country, the darker the color of the country (with square root scaling).

National Points of Entry

About the point of entries, we have 49 of them (one has no coordinates, for 106 entries), with Bogotá as the main one (57% of entries, 16,116,705), followed by Rionegro in Antioquia (10%, 2,903,333).

Clicking on the circles on the map will show a table with the totals of entries and a breakdown per year. The radius of the circles is scaled by the total over the 11 years.